Release 10.1A: OpenEdge Getting Started:
Database Essentials

Periodic monitoring tasks

There are tasks that you must perform on a periodic basis to promote monitoring of your system. Some of these tasks, like database analysis, should be done monthly. Other tasks should only be done as needed, such as a compacting an index.

Periodic OpenEdge maintenance tasks include:

Database analysis
Rebuilding indexes
Compacting indexes
Fixing indexes
Moving tables
Moving indexes
Truncating and growing BI files
Dumping and loading